"192.168.0.1:sipop" Previous topic Chapter index Next topic

TIPODOCUIDENT

 

 

Descriptions

TIPO DE DOCUMENTO DE IDENTIDAD

 

Fields

PK

FK

Name

Domain

Data type

Not null

Default

Description

 

ID_TIPO_DOCUMENTO

 

VARCHAR (2)

 

ID del tipo documento de identidad

 

 

NOMBRE_DOCUMENTO

 

VARCHAR (30)

 

Nombre del tipo de docuemtento de identidad

 

Triggers

There are no triggers for table TIPODOCUIDENT

 

Indices

There are no indices for table TIPODOCUIDENT

 

References

There are no references for table TIPODOCUIDENT

 

Referenced

Table

Foreign Key

Fields

FK Fields

DEL Rule

UPD Rule

DOCUMENTOS_DE_PERSONA

FK_DOCUMENTOS_DE_PERSONA

TIPO_DOCUMENTO_PERSONA

ID_TIPO_DOCUMENTO

RESTRICT

RESTRICT

 

Definition


CREATE TABLE TIPODOCUIDENT (
    ID_TIPO_DOCUMENTO VARCHAR (2) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMBRE_DOCUMENTO VARCHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE);

ALTER TABLE TIPODOCUIDENT ADD PRIMARY KEY (ID_TIPO_DOCUMENTO);

    This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m. Previous topic Chapter index Next topic